Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey guys, I have a PowerBI file with 5 data sources. Currently, 2 data sources are broken.
In Power Query editor, I edited the other 3 working tables. After the edit, I would click save and apply. But my query is blocked because of the 2 broken data sources. Is there a way to omit the 2 broken data sources when I click save and apply? I have already tried right clicking on the data source and de-selecting the "Refresh" option for the broken tables.
Thanks in advance!
Just an update on this. The only way for the other queries to not block any new calculations is to uncheck the "Enable Load" option as well.
In Power Query Editor , Just uncheck the "include in report Refresh" option ! That may help you!
Please let me know if it is not.
Proud to be a Super User!
Hi VijayP,
I have unfortunately already tried that and it does not seem to work. I disabled the "Include in report refresh" by right clicking the dataset and have also tried it by going into Properties, and disabling it there as well.
The data sources I am pulling from are all Web APIs. I'm not sure if that changes anything.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |