Forum Discussion
Invalid mashup connection string
Hi, sabake
I wonder what data sources you are conncectint to. Based on error message, it seems like there are something wrong with your datasource connection and parameters.
I'd like to suggest you to refer to the following links. If it still doesn't work, you may open a support ticket here .
Using the Power BI Service Parameters to change connection strings
Troubleshooting refresh scenarios
Troubleshoot gateways - Power BI
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Opened the ticket a none of the pages describe the issue encountered.
Interesting is, that dataset management page does not detect the rangestart and rangeend parameters, but the parameters are visible in the data model..
Case is still open, but for others who have encountered similar - PowerBI Desktop and PowerBI Service do data queries a bit differently, so successful data load in desktop do not mean successful data load in the service. Diligently following that native query is shown (and makes sense) in the desktop for all source (loaded from external DB) tables is the way to avoid surprises from the service.
I still have issues on service data load, but after ensuring all source db queries are correct the mashup connection string dissapeared - was replaces with various timeout errors. As I'm actually loading fact and dimension tables transformed from the source tables then issue is probably with the transformation methods.