Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
As stated on the topic, I have some strange behaviour on a dataflow. It works correctly, it shows data and returns no errors either on the records or on the refresh history. It has been working for months but as of late some tables on it doesn't show any data when connecting to them from another dataflow or the Power BI desktop app.
This is the diagram view (not complete because the dataflow is big, but what we can't see here doesn't impact or matter).
I've marked in black (the border edge) the tables which won't load data anywhere else (but they do inside de dataflow and no errors on the records).
Also, marked in green (the border edge) the source table (linked from another dataflow) and a table which is the result of a merge between the last black and another one (which we can't see here), them both return data on another dataflows or the Power BI desktop.
I've run out of ideas as how could I solve this.
- I've refreshed over and over with no changes.
- Changed the type of some columns in the first black table and refreshed.
I don't want to delete the flow and reupload it again as it has dependant dataflows and maybe dependant reports which point directly to some table.
Any suggestions on why does this happend and how could I solve this?
Solved! Go to Solution.
Hi @Damian_CT_Nom , thank you for reaching out to the Microsoft Fabric Community Forum.
Sorry to know none of the suggestions helped. Please consider below:
If this helps, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details.
Thank you.
Hi @Damian_CT_Nom , thank you for reaching out to the Microsoft Fabric Community Forum.
Please consider below:
If this helps, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details.
Thank you.
Hello @v-hashadapu, thank you for your answer.
Unfortunately none of this helped. Though I only had to try the first point as the other one already had been tested.
The thing is that only some tables inside the same dataflow won't show data even when no errors are prompted on refreshing and no rows on any table has errors.
Reupdating the authentication and changing the privacy didn't help either...
I don't know what else I could try to fix this. Because it has been working for the longest and it just stopped recently.
Hi @Damian_CT_Nom , thank you for reaching out to the Microsoft Fabric Community Forum.
Sorry to know none of the suggestions helped. Please consider below:
If this helps, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details.
Thank you.
Hi @v-hashadapu and thank you for your help.
Sadly this affects other dataflows too, so it isn't a matter of Power BI Desktop. Will try to contact MS support. Thanks.
User | Count |
---|---|
47 | |
27 | |
21 | |
19 | |
18 |
User | Count |
---|---|
54 | |
47 | |
22 | |
22 | |
20 |