Forum Discussion
Not able to refresh semantic model AND cannot publish to Power BI services from desktop
Hi dszarowski ,
When you create a report in Power BI and connect to an Excel file (e.g., from SharePoint), Import mode is usually the default. This mode loads data into Power BI’s in-memory model, enabling faster reporting.
DirectQuery, on the other hand, means the data is not loaded into Power BI but remains in the source (e.g., SharePoint, SQL Server) and is queried directly when needed. DirectQuery is often used for larger datasets or real-time access.
Although your report may have been created with Import mode, it could have switched to DirectQuery due to IT changes. This could happen if:- IT modified the permissions or access configurations for the data source. There was a change in how SharePoint or the file you're accessing is being handled (e.g., server-side configurations). Power BI detected that your dataset was large or complex and switched to DirectQuery to optimize performance.
Once you confirm it with them and if the issue still persists, I suggest raising a support case with Microsoft.
To raise the support ticket, please follow the link below:https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
The response was helpful, although it did not resolve the issue. When discussing with IT they were not able to confirm or deny any changes to my permissions (which was not helpful) not were we able to solve thiws issue. I confirmed all credentials are correct and the pathway to my underlying dataset in SharePoint looks correct as well.
A question I have is why would my report all of a sudden require a direct query connection? Wasn't it already automatically set up like that when I created the report and connecgted to the data source?
Hi dszarowski ,
When you create a report in Power BI and connect to an Excel file (e.g., from SharePoint), Import mode is usually the default. This mode loads data into Power BI’s in-memory model, enabling faster reporting.
DirectQuery, on the other hand, means the data is not loaded into Power BI but remains in the source (e.g., SharePoint, SQL Server) and is queried directly when needed. DirectQuery is often used for larger datasets or real-time access.
Although your report may have been created with Import mode, it could have switched to DirectQuery due to IT changes. This could happen if:
- IT modified the permissions or access configurations for the data source. There was a change in how SharePoint or the file you're accessing is being handled (e.g., server-side configurations). Power BI detected that your dataset was large or complex and switched to DirectQuery to optimize performance.
Once you confirm it with them and if the issue still persists, I suggest raising a support case with Microsoft.
To raise the support ticket, please follow the link below:
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
Hi @dszarowski ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hello dszarowski ,
Could you please confirm whether the previous suggestion has resolved your issue or if you have raised any support tickets? Please feel free to contact us if you have any further questions.
Thank you.