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.
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.