Forum Discussion
Developing Paginated reports from Visual Studio instead of Report builder?
I was finally able to test out both methods, and i wanted to post an update incase anyone else was searching on this topic. You are able to use Visual studio for this as well as Power BI Report Builder, so chose the tool you are more comfortable with and you are good to go.
In Visual Studio, are you able to build a Paginated Report using a published Power BI Dataset (in a Premium Capacity) as a Data Source?
If so, what steps need to be taken to create the Data Source in Visual Studio to connect to the Power BI Dataset?
I've created many SSRS reports in the past targeting Analysis Services as a data source, but using Power BI Report Builder is a painful process. It is very slow for me and crashes often. If it's possible to use the more stable toolset of Visual Studio rather than Power BI Report Builder, I would like to do so.
You can use the XMLA endpoint. https://powerbi.microsoft.com/en-us/blog/power-bi-open-platform-connectivity-with-xmla-endpoints-public-preview/
I was able to get this working in Visual Studio using the XMLA endpoint, but it was a little tricky. It gave connection errors that I had to ignore, then go to the seperate Credentials page on the Data Source Properties and set it to "Prompt for credentials" in order for the connection to the Power BI Premium Dataset to work.
However, I ran in to the sames issues in Visual Studio as I did in Power BI Report Builder which is the issue here:
I will reply to that thread to continue the conversation.
Thanks for your help.