Forum Discussion
Dataflow - No table show up in Desktop
- Anonymous6 years ago
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
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.
- Anonymous6 years agoNot applicable
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
- nankerp6 years ago
Helper III
The samplefile is Exceltabel. 3000 rows. I have also tried an Access file.
Here is link to a file with screenshot:
- Anonymous6 years agoNot applicable
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