Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
I have made a dataflow with connection to an Excel table. I try to connect to this table from Desktop but no table show up. I thought this should be an easy thing to do.
Solved! Go to Solution.
Hi @nankerp ,
It may be because other account used to obtain dataflow data in Power BI Desktop before, and PBD remember and saved the this "other" account. Please clear the permission of this account and sign in with the current account.
1. Click Files –> “Options and settings” – “Data source settings”, then find “Power BI Dataflows” in “Global Permission” to clear Permission.
2. Get data--> Power BI dataflows--> Sign in
Best Regards
Rena
Refer to this : https://community.powerbi.com/t5/Service/Just-started-this-week-DATAFLOW-table-does-not-show-up-in-P...
https://community.powerbi.com/t5/Desktop/Data-Not-Showing-Up/m-p/236485
I have read through this post but can not get it to work. I try to connect to the users dataflow but no tables show up.
Hi @nankerp ,
Please check whether you face the similar problem in "Troubleshooting" part of this documentation, if yes, you can refer the related solution to resolve it.
Best Regards
Rena
Sorry, it still does not work.
It is so strange. I thought everything should be so straight forward. I have a dataset (entity) in dataflow. Normaly it should show the tables when I try to connect via PBD.
Hi @nankerp ,
I am not sure if the problem is with the data in the excel sheet... Could you please provide some sample data in excel table and the screenshot of the result when create dataflow with connection to excel? And if you can connect to this excel table in Power BI Desktop? Where the excel be stored? Please check if it hit any limitations in this documentation.
In addition, please check if the following links can help you.
Can't connect PowerApps and Power BI to same excel file
Create a report connecting to Excel file on OneDrive
Best Regards
Rena
The samplefile is Exceltabel. 3000 rows. I have also tried an Access file.
Here is link to a file with screenshot:
Hi @nankerp ,
Whether you are the owner of this dataflow? And the accounts which sign in Power BI Service and Power BI Desktop are same?
Best Regards
Rena
I can confirm that the user in PBS and PBD is the same.
Hi @nankerp ,
It may be because other account used to obtain dataflow data in Power BI Desktop before, and PBD remember and saved the this "other" account. Please clear the permission of this account and sign in with the current account.
1. Click Files –> “Options and settings” – “Data source settings”, then find “Power BI Dataflows” in “Global Permission” to clear Permission.
2. Get data--> Power BI dataflows--> Sign in
Best Regards
Rena
Thank you so much. It solved the problem.
User | Count |
---|---|
93 | |
92 | |
85 | |
83 | |
49 |
User | Count |
---|---|
150 | |
142 | |
112 | |
73 | |
55 |