Switching Power BI datasets with Project File (.pbip)

[Anonymous]

When saving a Power BI report (.pbix) as a project file (.pbip), Power BI desktop no longer allows for switching the data source if connected to a power bi dataset (the message "A DirectQuery connection is required" is displayed).

As an example, if I am working on a report in Power BI desktop that connects to a power bi datatset in the power bi service and then save that pbix file as a pbip file, I can no longer change the data source to a different power bi dataset. Pbix files allow the user to switch the Power BI dataset to which the report is connected, .pbib files do not. This functionality is needed when creating a report against a development dataset and then being able to switch the connection to the production version.  

Thanks,

Eric

[Anonymous]

Hi  @Anonymous 

Thanks for your feedback , it is true that this feature is not currently supported. You can vote the idea and comment there to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,
Community Support Team _ Ailsa Tao