Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape 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.

Reply
nankerp
Helper III
Helper III

Dataflow - No table show up in Desktop

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.

1 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.

clear permission.jpg

2. Get data--> Power BI dataflows--> Sign in

Best Regards

Rena

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

10 REPLIES 10
amitchandak
Super User
Super User

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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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...

 

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

clear permission.jpg

2. Get data--> Power BI dataflows--> Sign in

Best Regards

Rena

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you so much. It solved the problem.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.