Forum Discussion
Invalid mashup connection string
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.