Testing dataflows in Power BI Pro and Premium accounts
Vložit
- čas přidán 27. 11. 2018
- In today's video we are going to put all the theory from Monday's video into practice and we are going to create a dataflow in a Power BI Pro and Premium account.
If you missed the video on Monday, check it out here:
• What is a Power BI dat...
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
Regarding loading data twice, you can right-click on an entity and choose whether to "Enable Load" in Pro. Reference is another option.
Thanks for that! I will pin the comment for more visibility :)
/Ruth
Looks like the premium capacity is the way to go with data flows. Thank you for the comparison Ruth! Can you do another video where you connect your entity to Azure ML Studio and run a quick experiment? Connecting clean/refreshing data to a ML model only to be pulled back into Power BI Desktop will be a game changer for self service advanced analytics.
Funny you ask! I though of doing it in this video but it was already too long. Got to do it on a future video!
/Ruth
Thanks Ruth, great video, out of curiousity which kind of data could not be loaded? What kind of restrictions are there ? ca. 9:10
The ones I deleted, the columns that you can expand to join with other tables.
You should be able to see me delete them.
/Ruth
Hi Ruth, I think that Daniel meant what data type(s) were those unloadable columns that you had to delete?
is it possible to consume premium per user dataflows in pro workspace ?
Hi Ruth, thanks for your video! It helps a lot! :)
At the moment, I am exploring Power BI dataflows.
I have a question, maybe you can help me.
I created a new Power Bi dataflow where my data source is a Google Analytics site, throught the "Blank query" connection type and it works. However I need to know what I can update the data, because I gateway is not available and I tested as your example and I give me an error! Thanks in advance :)
Thank you, Ruth. What's your experience with local data and gateway? Most of the datasets that I deal with are flat files on our network drives, and I have not been able to successfully set up any dataflows with them due to a credential error (although the credentials are correct). I wanted to see if you have had any issues as well. (and I'm so jealous of your access to the premium account...)
Haven’t tried it yet, I will give it a go let you know!
I know right? Really lucky to have one :)
/Ruth
Hachi... have you found a solution?
@@dasrotrad , no, I'm still unable to use dataflows due to the credential issue...
And I haven’t had the time to test it yet, sorry guys!
/Ruth
Need your help please, Can we use stored procedures having multiple parameters in power bi? I have already explored & asked this question powerbi community.
Appreciate your help.
I dont know, i am afraid...
/Ruth
I use SQL Function successfully. I am using in data flow too.
Hola Ruth! ¿Que licencia ocupas para tener disponible premium y cuanto dinero es aprox. para poder probar todas las funcionalidades asociadas? Mi idea es probar y aprender.
Hola Victor,
Las licencias premium no se pueden adquirir como test, la única forma es pagar la licencia al mes de 5k dólares :(
/Ruth
@@CurbalENEntonces en tu empresa usan premium y por eso lo puedes probar? O como lo haces :0?
Mi empresa soy yo, pero tengo una licencia de MVP..
/Ruth
How can i add that northwind dataset through odata, i do not have sql server installed on pc.
Here you have a tutorial:
m.czcams.com/video/k3NMIlLffrU/video.html
/Ruth
Thanks 🙏🙇
Hi Ruth, Love your video. I think that most of us will be looking to move our core Power Query functionality out of PBI Desktop and into a Dataflow (so that we can then share best practice), so I've been trying to understand the current limitations of cutting and pasting between Advanced Editors. Currently, the biggest issue for me is that I cannot use Parameters in a Dataflow. Without that, I lose a whole range of configurability in my M code. I'm sure that Microsoft will be adding more and more into what we can do, but what other problems/limitations have you found when porting functionality across into Dataflows?
It depends on the subscription, the pro subscription is quite limited...
Microsoft needs more time to develop dataflows, but their release cycles are really short, specially in the cloud, so you won’t have to wait long :)
/Ruth
I agree about the release cycle length - very agile! I'm using a Premium license, but I still think that we're 6 - 12 months away from having functional parity between Desktop PQ and PQ Online...
Difficult to say how long it will take, but you are probably right, 6-12 months sounds reasonable.
Great that time flies ;)
/Ruth
Ruth: I hope you can shed some light, and maybe a video on connecting workspace datasets with the datasource, which in this instance is an excel workbook.
I am using Power BI PRO subscription. I am getting the following error:
Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again. and then follows the message:
(admin has granted access, credentials are not required) I am not the only person having this issue. I see posted in Power BI community the same questions. I don't know how to resolve it which renders the dataflow scenario useless. Thank you. Robert
Have you reported it here: issues.powerbi.com?
Dataflows are on early beta....
/Ruth
@@CurbalEN Thank you so very much for your reply. I did post on issues.powerbi.com There are many many posts from users on this same issue. I have spent hours looking for a solution. I have searched through blogs and searched many videos. Something is wrong with my endpoint connection. I have a Power BI PRO account and requested support four days ago, but no response from MS. It is probably a simple solution. I can't understand the credentialing process. The strangest thing is, I am getting an error that says my credentials are invalid followed by the statement that credentials are not required. What can that mean? Makes no sense to me.
Ruth: Microsoft did respond to my support request after 4 days. I am delighted to say, that after two hours on the phone, the issue was resolved by removing my gateways and creating new gateways. The Technician told me I should be saving a recovery key during the process of creating a new gateway. I never saw any means of doing so. So, if my gateway becomes corrupted again, I won't be able to recover and will have to go through the process again. There is a lot to learn about gateways and dataflows. I hope you or other MVPs will continue to address how to structure this environment so we mere mortals can use it. It is scary for me for when a client wants an updated report, for now, I can't be sure I can deliver. With all that said, I am very grateful to you in particular and other MVPs in general for all the support and training that you and your colleagues generously provide. Your humble student..... Robert a/k/a Dasrotrad
Oldest trick in the book right? In Sweden they call it “Norwegian reset”, not sure why 😂😂
The innovation pace they have is tough for all to follow, I assure you that!
I am also really grateful for all the people that blog, vlog or comment about it so we can learn from each other, like you did now on this comment 😊.
Be sure it is going to help somebody! .
That is the best part of belonging to such a great community, right?
/Ruth