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.
Hello dszarowski ,
Thank you for reaching out to the Microsoft Fabric Community Forum.
For publishing Issue :
When attempting to publish your report from Power BI Desktop, you may be prompted to rename the file, which can result in duplicate reports in your workspace. To resolve this issue, please follow these steps:
- Verify that your workspace settings remain unchanged, as IT updates can sometimes modify permissions or settings.
- Ensure you are using the latest version of Power BI Desktop, as updates can often resolve unexpected issues.
- Clear the cache in Power BI Desktop by navigating to File > Options and settings > Options > Data Load and clearing the cache.
- If the issue persists, save the report with a new name and re-publish it. After publishing, you may delete the duplicate report from your workspace.
For Auto Refresh and Credential issues :
It appears that your auto-refresh is not functioning correctly, preventing you from updating your credentials or refreshing the semantic model. Please follow these steps to troubleshoot the issue:
- Navigate to Settings > Data source credentials in the Power BI service to ensure your credentials are current.
- The notice regarding Direct Query connection might suggest a change in data source access. Verify that your data source supports Direct Query and that your credentials have the necessary permissions.
- Re-authenticating your data source can sometimes resolve credential issues. Go to Settings > Data source credentials and re-enter your credentials.
- If using an on-premises data gateway, ensure it is running and properly configured. Gateway issues can occasionally cause refresh failures.
Below are some useful links and resources that may assist you further. Please review them for a better understanding:
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-upload-desktop-files
refresh-in-power-bi-desktop-vs-power-bi-service
Incremental refresh for semantic models in Power BI - Power BI | Microsoft Learn
I hope this should resolve your issue, if you need any further assistance, feel free to reach out.
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.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.
