Forum Discussion
Dataset_Import_FailedToImportDataset
I just talked to Microsoft support and they helped me work through this issue. Here's what I had to do.
1. In PBI Service, from the workspace where Dataset_Import_FailedToImportDataset occurred, create a new branch as decribed in this article.
2. Open the affected report(s) in PBI Desktop and publish to the service
3. In the PBI workspace, validate the the conflict has been resolved and commit the changes to the branch created in step 1.
4. Merge the branch back into the source
5. Swap the workspace back to the source branch
It seems like you're encountering an error when trying to use Git integration with Power BI Desktop and saving files in .pbix format, specifically when importing data from Snowflake. Here are a few steps you can take to troubleshoot and potentially resolve the issue:
Check Data Source Credentials: Ensure that the data source credentials for Snowflake are correctly configured in Power BI Desktop. If the credentials are invalid or expired, it can cause import failures.
Review Power BI Desktop Logs: Check the Power BI Desktop logs for more detailed error messages or warnings. You can access the logs by selecting "Help" > "View logs" from the Power BI Desktop menu.
Verify Data Source Connectivity: Confirm that Power BI Desktop can successfully connect to Snowflake and retrieve data without any errors. You can test the connection by creating a new query or refreshing existing queries in Power BI Desktop.
Check Dataset Size: If the dataset being imported from Snowflake is large, it may exceed Power BI Desktop's memory limitations, especially when saving to .pbix format. Consider optimizing the dataset or using DirectQuery mode to query the data directly from Snowflake instead of importing it into Power BI Desktop.
Review Git Integration Settings: Double-check the Git integration settings in Power BI Desktop to ensure that the repository and branch are configured correctly. Verify that you have the necessary permissions to push changes to the repository in Azure DevOps Git.
Update Power BI Desktop: Ensure that you're using the latest version of Power BI Desktop. Microsoft regularly releases updates and bug fixes that may address issues with Git integration and data import.
Check Azure DevOps Settings: Review the settings and permissions in Azure DevOps to ensure that there are no restrictions or limitations that could be affecting the Git integration process.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!