Forum Discussion

Gwendaline_p's avatar
Gwendaline_p
Helper I
9 years ago

Unable to open PowerBI document

Hi everyone ,   I created a PowerBI document with data from an ODBC source. I saw all data in the document but after save and close the document I can't open the PowerBI document anymore ... (see t...
Need Help
Gwendaline_p's avatar
Gwendaline_p
Helper I
9 years ago

Hi everyone ,

 

I don't have any issue with the connexion to my data source. I changed my SQL request to add a limit.

Before : select * from table where month like "201611";

Now : select * from table where month like "201611" limit 1000;

==> I don't have anymore the issue when I used limitations.

Can it be linked to the size of my data table ? (for information my data table is about 10 Go, more than 10 millions lines)

 

The .pbit doesn't work. I have the same error message when I open it.

 

The .zip works but as you said I don't have my source information so no more data, I have to refresh again and I have a lot of data (1hour of importation). I don't have the time to download all the data each time that I open the dashboard ... And I lose all the connections between variables and graphics.

 

With the latest version of PowerBI , my ODBC connector doesn't work anymore ...

 

Kind regards ,

Gwendaline