Dataflow - No table show up in Desktop

[nankerp]

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.

[amitchandak]

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

[nankerp]

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.

[v-yiruan-msft]

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

[nankerp]

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.

[v-yiruan-msft]

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

Connect data flow to Excel file stored in OneDrive

Create a report connecting to Excel file on OneDrive

Connecting to Excel on SharePoint

Best Regards

Rena

[nankerp]

The samplefile is Exceltabel. 3000 rows. I have also tried an Access file.

Here is link to a file with screenshot:

https://plenaas-my.sharepoint.com/:x:/g/personal/helge_klungland_plena_no/EQOqmKUKGVZHrOi9soQG0yAB7h...

[v-yiruan-msft]

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

[nankerp]

I can confirm that the user in PBS and PBD is the same.

[v-yiruan-msft · Accepted 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

[nankerp]

Thank you so much. It solved the problem.