Forum Discussion
Reports won't publish - Direct Query
Thanks for that, i was able to fix it. Initially i was saving my files as PBIB and now i have changed to PBIX and it fixed the publishing error. I know get a success message after publishing this includes if i make changes to the report and republish
Nice to hear!
Thanks for the update.
rajendraongole1 sorry to ask but i actually dont know why but would you know why it worked via PBIX and not PBIB?
Hi ViralPatel212 - as you mentioned, when working in Power BI Desktop, you can import data and create a local model where transformations or dataset merging is possible because all the data is stored and processed locally.
In Power BI Service, live connection mode strictly queries the underlying dataset and doesn’t allow alterations or combining other sources. This ensures the integrity and performance of the underlying Semantic Model but limits flexibility.(pbib)
ref links:
Hope this information helps.