Forum Discussion
Datasets versus Excel
Huh, so someone built some kind of custom integration or something to extract the information out of the ERP straight into datasets in Power BI? And so now all you have in Power BI are datasets which, of course, you can only connect to one at a time via Live connection, right?
I have to believe that if they created these datasets, they did so via Power BI Desktop so perhaps the answer is to get your hands on those PBIX files. Otherwise, if you have Premium, perhaps you could connect a dataflow and use linked entities, wait, no that won't work, dataflow can't go against a Power BI dataset.
I have to believe that somewhere some Power BI Desktop PBIX files exist that created those datasets. Otherwise, I would be interested to know how they created those datasets.
Hi Greg - So in the end, what is was is that oursysadmin and the developers had mistakenly thought that I could connect my data model (in my desktop) to multiple data sets.
After I showed them this was not possible, what did actually work was using the Get Data (Web) feature, and connected to what I believe was a json query using various query strings, and that did indeed work. If I'm not mistaken, the query strings were connecting to tables in the ERP database itself